 |
Spreadsheet modelling
Aim purpose
The aim of this unit is to give learners a knowledge of the uses of spreadsheets and enable them to develop,
test and document spreadsheet modelsSpreadsheets can be used in many different situations, such as finance and engineering and the unit content
includes a wide range of spreadsheet features, formulae and functions. In addition, spreadsheet users need
to be able to choose from a variety of different ways of presenting and analysing spreadsheet data, including
producing graphs and filtering and sorting lists of data. Learners will be able to combine the skills developed to
produce a spreadsheet model that is tailor made for the specific needs of the userTo speed up the use of spreadsheets, shortcuts are often used to enter data or duplicate particular
combinations of keystrokes. Learners will be able to create such shortcuts and recognise their potential in
improving efficiency.1 Know what spreadsheets are and how they can be used
2 Be able to develop spreadsheet models
3 Be able to test and document spreadsheet models.
